﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_CAR_STATION_Get_Station_Location')
	BEGIN
		DROP Procedure usp_UPDMS_CAR_STATION_Get_Station_Location
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_CAR_STATION_Get_Station_Location
**	Desc : 차량관련업소 위치정보
**	Test Exec Query : Exec usp_UPDMS_CAR_STATION_Get_Station_Location ''
**	Called by : Ref_Dac_UPDMS_CAR_STATION.cs
**	Program ID : NaverMapMulitMarker
**	Auth : 송시명
**	Date : 2013-05-14
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_CAR_STATION_Get_Station_Location]
@ls_use_yn nvarchar(1)
AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET NOCOUNT ON

SELECT Latitude + ',' + Longitude + ',' + Station_Nm AS Markers
  FROM UPDMS_CAR_STATION WITH(NOLOCK)
 WHERE LEN(Latitude + Longitude) = 12
   AND Use_Yn LIKE @ls_use_yn + '%'

GO